All About Oracle Database Fragmentation
نویسنده
چکیده
There are many types of Oracle database fragmentation. Some are harmful and some are not. An active Oracle database will naturally foster harmful database fragmentation unless the DBA takes proactive application design and space management steps. This paper addresses tablespace freespace, segment, data block, index leaf block, and row fragmentation. Each fragmentation type is described in detail along with how to detect the fragmentation, how to quantify its intensity, what its performance and administration affects are, and how to resolve only the harmful fragmentation. Various scripts are used throughout the paper and references are made to publicly available tools.
منابع مشابه
Intelligent Implementation Processor Design for Oracle Distributed Databases System
Despite the increasing need for modeling and implementing Distributed Databases (DDB), distributed database management systems are still quite far from helping the designer to directly implement its BDD. Indeed, the fundamental principle of implementation of a DDB is to make the database appear as a centralized database, providing series of transparencies, something that is not provided directl...
متن کاملDistributed University Registration Database System Using Oracle 9i
In database and information systems, increasing attention has been focused lately on parallel and distributed database systems. The future of large database systems lies into the realm of distributed computing. The main reason for this is that distributed computing can be constructed at a low cost without the need for any specialized technology, using existing sequential computers and relativel...
متن کاملConducting a Security Audit of an Oracle Database
Conducting a Security Audit of an Oracle Database The focus of the paper is on auditing access controls to Oracle databases. What should the auditor evaluate and test to enable him to give an informed opinion about the security of an information system based on an Oracle database? A number of issues that the auditor should evaluate are discussed in the paper, with indications of how these issue...
متن کاملOracle essentials - Oracle8 and Oracle8i: what you need to know about Oracle database architecture and features
متن کامل
A Bibliography of Books and Manuals on the Oracle Database System
This bibliography records books about the Oracle database system. Title word cross-reference
متن کامل